package com.lagou.mapper;

import com.lagou.domain.Role;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface RoleAnno {
	@Select("SELECT * FROM sys_role r INNER JOIN sys_user_role ur ON r.`id` = ur.`roleid` where ur.`userid` = #{uid} ")
	public List<Role> findRoleByUid(Integer uid);
}
